SELECT objindex_objtitle, objindex_objtype,objinfo_briefinfo,objindex_id,objinfo_thumbnail,objindex_addeddate ,category_name,post_title,quiz_title ,(select count(1) from member_stats where stats_fkobjectid =objindex_id ) as totalviews from tbl_objectindex LEFT JOIN tbl_objectdetail on objindex_id=objinfo_fkobjid and objindex_objtype = objinfo_objtype LEFT JOIN tbl_category on objinfo_catid = category_id LEFT JOIN post_overview on objindex_fkpostid = post_id LEFT JOIN quiz_info on objindex_fkquizid = quiz_id LEFT JOIN tbl_moduletype on objindex_moduletype = module_id LEFT JOIN tbl_objsubcatg on objsubcat_fkobjid = objindex_id WHERE 1 = 1 and `objindex_status` = 10 and `objsubcat_subcatid` = 2 order by objindex_order ASC limit 0 , 12
PAGE TITLE
